using System;
using System.Data;
using System.Collections.Generic;
using System.ServiceModel;
using eTMS.DAO;
namespace eTMS.Services
{
    /********************************BEGIN SinhVienService****************************************/
    ///<summary>
    /// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
    /// <para>Date:09/08/2010 12:01:35</para>
    /// <para>Class Name: SinhVienService</para>
    /// <para>Description: </para>
    ///</summary>


    public partial class SinhVienService
    {
        public DataSet SearchSinhVien(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVien(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity);
        }

        public DataSet SearchSinhVienChuaPhanLop(int NganhHoc_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienChuaPhanLop(NganhHoc_ID, KhoaHoc_ID, sinhVienEntity);
        }

        public bool DeleteSinhVienByListSinhVien_ID(List<int> lsSinhVien_ID)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.DeleteSinhVienByListSinhVien_ID(lsSinhVien_ID);
        }

        public DataSet SearchSinhVienWithDiemMonHoc(bool AllowLeftJoinSinhVienMonHoc, bool IsJoinToDiemMonHoc, bool IsJoinToDangKyHocPhan, bool IsJoinToSinhVienLopTinChi, int MonHoc_ID, int LoaiDiem_ID, int LanThi, int HocKy_ID, int NamHoc_ID, int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, string Filter)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienWithDiemMonHoc(AllowLeftJoinSinhVienMonHoc, IsJoinToDiemMonHoc, IsJoinToDangKyHocPhan, IsJoinToSinhVienLopTinChi, MonHoc_ID, LoaiDiem_ID, LanThi, HocKy_ID, NamHoc_ID, Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity, Filter);
        }
        public DataSet SearchDataCommonUpdate(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, string TableUpdate, List<string> LsColumnUpdate, string ColumnLink, string Column_ID, bool IsInnerJoin, SinhVienEntity sinhVienEntity, string Filter)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchDataCommonUpdate(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, TableUpdate, LsColumnUpdate, ColumnLink, Column_ID, IsInnerJoin, sinhVienEntity, Filter);
        }
        public DataSet SelectDataLookUpTable(string TableLookUp, string ValueMember, string DisplayMember)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SelectDataLookUpTable(TableLookUp, ValueMember, DisplayMember);
        }
        public bool UpdateDataCommon(string TableUpdate, string Column_ID, string ColumnUpdate, object Value, object ID)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.UpdateDataCommon(TableUpdate, Column_ID, ColumnUpdate, Value, ID);
        }

        public DataSet SearchSinhVienNopTien(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, int NamHoc_ID, int HocKy_ID, DateTime TuNgay, DateTime DenNgay, bool IsFindByNgay, byte KieuThanhToan)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienNopTien(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity, NamHoc_ID, HocKy_ID, TuNgay, DenNgay, IsFindByNgay, KieuThanhToan);
        }

        public DataSet TongHopDoiTuongTroCap(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, int NamHoc_ID, int HocKy_ID)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.TongHopDoiTuongTroCap(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity, NamHoc_ID, HocKy_ID);
        }

        public DataSet SearchDanhSachHocBong(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, int NamHoc_ID, int HocKy_ID)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchDanhSachHocBong(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity, NamHoc_ID, HocKy_ID);
        }
        public DataSet SearchSinhVienUsers(List<int> lsSinhVien_ID)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienUsers(lsSinhVien_ID);
        }
        public DataSet SearchSinhVienLopHocPhan(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, List<int> lsLopHocPhan_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienLopHocPhan(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, lsLopHocPhan_ID, sinhVienEntity);
        }
        public DataSet SearchSinhVienWithDiemTongKetHocKy(int HocKy_ID, int NamHoc_ID, int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienWithDiemTongKetHocKy(HocKy_ID, NamHoc_ID, Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity);
        }
        public DataSet SearchSinhVienHocLai(int NamHoc_ID, int HocKy_ID, int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienHocLai(NamHoc_ID, HocKy_ID, Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity);
        }
        public DataSet SelectAllDSDataBySQL(string SQL, Dictionary<string, object> Parameters)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SelectAllDSDataBySQL(SQL, Parameters);
        }
        public DataSet SearchSinhVien_ID(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVien_ID(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity);
        }
        public DataSet SearchSinhVienHocMonHoc(int MonHoc_ID, int NamHoc_ID, int HocKy_ID, int Lop_ID, SinhVienEntity sinhVienEntity)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.SearchSinhVienHocMonHoc(MonHoc_ID, NamHoc_ID, HocKy_ID, Lop_ID, sinhVienEntity);
        }
        public DataSet ThongKeSinhVien(int Khoa_ID, int NganhHoc_ID, int Lop_ID, int KhoaHoc_ID, SinhVienEntity sinhVienEntity, string TableJoin, string DisplayColName, string JoinKey, bool IsInnerJoin)
        {
            SinhVienDAO dao = new SinhVienDAO();
            return dao.ThongKeSinhVien(Khoa_ID, NganhHoc_ID, Lop_ID, KhoaHoc_ID, sinhVienEntity, TableJoin, DisplayColName, JoinKey, IsInnerJoin);

        }
        public DataSet SelectAllDSSinhVienByListID(List<int> LsSinhVien_Id)
        {

            SinhVienDAO dao = new SinhVienDAO();
            return dao.SelectAllDSSinhVienByListID(LsSinhVien_Id);
        }
    }
    /*****************************************************************************************************/
    /**********************************END SinhVienWebService*****************************************/
    /*****************************************************************************************************/
}

